package com.cpi.cornpp.purchase.program.dto;

/**
 * Purchase Program Data Transfer Object
 * 
 * @author Edgar Joao
 * 
 */
public class PurchaseProgramDTO {

	/**
	 * Nombre de la columna Periodo
	 */
	public static final String PERIOD = "period";
	/**
	 * Nombre de la columna Periodo
	 */
	public static final String COMPLETE_PERIOD = "convert( varchar, year ) +(case when month < 10 then '0' else '' end)+convert( varchar, month )+'0'+convert( varchar, biweek )";
	/**
	 * Nombre de la columna b No
	 */
	public static final String B_NO = "code, code_number";
	/**
	 * Nombre de la columna b No NUMBER
	 */
	public static final String B_NO_NUMBER = "code_number";

	/**
	 * Nombre de la columna Futuros
	 */
	public static final String FUTURES = "futures";
	/**
	 * Nombre de la columna Tonelaje
	 */
	public static final String TONS = "tons";
	/**
	 * Nombre de la columna Precio $Bu
	 */
	public static final String PRICE_BU = "priceBu";
	/**
	 * Nombre de la columna Base $Bu
	 */
	public static final String BASE_BU = "base_bushel";
	/**
	 * Nombre de la columna Precio US BU 
	 */
	public static final String PRICE_US_BU = "priceUsBu";
	/**
	 * Nombre de la columna Precio US TM
	 */
	public static final String Price_US_TM = "priceUsTm";
	/**
	 * Nombre de la columna Val Real Fut
	 */
	public static final String VAL_REAL_FUT = "real_value";
	/**
	 * Nombre de la columna Real + Base
	 */
	public static final String VAL_BASE = "valBase";
	/**
	 * Nombre de la columna C. Real $/TM
	 */
	public static final String C_REAL_TM = "cRealTm";
	
	
	String period;
	String bNo;
	int bNoNumber;
	double futures;
	double tons;
	double priceBu;
	double baseBu;
	double priceUsBu;
	double priceUsTm;
	double valRealFut;
	double valBase;
	double cRealTm;
	int purchaseOrderId;
	int biweekPeriodInitId;
	int biweekPeriodFinishId;
	int transportId;
	String sapAssigned;
	String futureAssigned;
	String bushelPriceAssigned;
	
	public String getBushelPriceAssigned() {
		return bushelPriceAssigned;
	}
	public void setBushelPriceAssigned(String bushelPriceAssigned) {
		this.bushelPriceAssigned = bushelPriceAssigned;
	}
	public String getFutureAssigned() {
		return futureAssigned;
	}
	public void setFutureAssigned(String futureAssigned) {
		this.futureAssigned = futureAssigned;
	}
	
	
	public String getSapAssigned() {
		return sapAssigned;
	}
	public void setSapAssigned(String sapAssigned) {
		this.sapAssigned = sapAssigned;
	}
	public String getPeriod() {
		return period;
	}
	public void setPeriod(String period) {
		this.period = period;
	}
	public String getbNo() {
		return bNo;
	}
	public void setbNo(String bNo) {
		this.bNo = bNo;
	}
	public double getFutures() {
		return futures;
	}
	public void setFutures(double futures) {
		this.futures = futures;
	}
	public double getTons() {
		return tons;
	}
	public void setTons(double tons) {
		this.tons = tons;
	}
	public double getPriceBu() {
		return priceBu;
	}
	public void setPriceBu(double priceBu) {
		this.priceBu = priceBu;
	}
	public double getBaseBu() {
		return baseBu;
	}
	public void setBaseBu(double baseBu) {
		this.baseBu = baseBu;
	}
	public double getPriceUsBu() {
		return priceUsBu;
	}
	public void setPriceUsBu(double priceUsBu) {
		this.priceUsBu = priceUsBu;
	}
	public double getPriceUsTm() {
		return priceUsTm;
	}
	public void setPriceUsTm(double priceUsTm) {
		this.priceUsTm = priceUsTm;
	}
	public double getValRealFut() {
		return valRealFut;
	}
	public void setValRealFut(double valRealFut) {
		this.valRealFut = valRealFut;
	}
	public double getValBase() {
		return valBase;
	}
	public void setValBase(double valBase) {
		this.valBase = valBase;
	}
	public double getcRealTm() {
		return cRealTm;
	}
	public void setcRealTm(double cRealTm) {
		this.cRealTm = cRealTm;
	}
	public int getPurchaseOrderId() {
		return purchaseOrderId;
	}
	public void setPurchaseOrderId(int purchaseOrderId) {
		this.purchaseOrderId = purchaseOrderId;
	}
	public int getBiweekPeriodInitId() {
		return biweekPeriodInitId;
	}
	public void setBiweekPeriodInitId(int biweekPeriodInitId) {
		this.biweekPeriodInitId = biweekPeriodInitId;
	}
	public int getBiweekPeriodFinishId() {
		return biweekPeriodFinishId;
	}
	public void setBiweekPeriodFinishId(int biweekPeriodFinishId) {
		this.biweekPeriodFinishId = biweekPeriodFinishId;
	}
	public int getTransportId() {
		return transportId;
	}
	public void setTransportId(int transportId) {
		this.transportId = transportId;
	}
			   
	public int getbNoNumber() {
		return bNoNumber;
	}
	public void setbNoNumber(int no_number) {
		bNoNumber = no_number;
	}
	
				
}
